/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package converter.core.db.entity;

import java.io.Serializable;
import java.math.BigInteger;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 *
 * @author Snark
 */
@Entity
@Table(name = "ORGANIZATIONS")
@NamedQueries({
    @NamedQuery(name = "Organizations.findAll", query = "SELECT o FROM Organizations o"),
    @NamedQuery(name = "Organizations.findBySysFldorder", query = "SELECT o FROM Organizations o WHERE o.sysFldorder = :sysFldorder"),
    @NamedQuery(name = "Organizations.findBySysGuid", query = "SELECT o FROM Organizations o WHERE o.sysGuid = :sysGuid"),
    @NamedQuery(name = "Organizations.findBySysState", query = "SELECT o FROM Organizations o WHERE o.sysState = :sysState"),
    @NamedQuery(name = "Organizations.findBySysRev", query = "SELECT o FROM Organizations o WHERE o.sysRev = :sysRev"),
    @NamedQuery(name = "Organizations.findBySysCreated", query = "SELECT o FROM Organizations o WHERE o.sysCreated = :sysCreated"),
    @NamedQuery(name = "Organizations.findBySysUpdated", query = "SELECT o FROM Organizations o WHERE o.sysUpdated = :sysUpdated"),
    @NamedQuery(name = "Organizations.findBySysCreator", query = "SELECT o FROM Organizations o WHERE o.sysCreator = :sysCreator"),
    @NamedQuery(name = "Organizations.findBySysUser", query = "SELECT o FROM Organizations o WHERE o.sysUser = :sysUser"),
    @NamedQuery(name = "Organizations.findBySysGuidfk", query = "SELECT o FROM Organizations o WHERE o.sysGuidfk = :sysGuidfk"),
    @NamedQuery(name = "Organizations.findBySysParentguid", query = "SELECT o FROM Organizations o WHERE o.sysParentguid = :sysParentguid"),
    @NamedQuery(name = "Organizations.findByOrgname", query = "SELECT o FROM Organizations o WHERE o.orgname = :orgname"),
    @NamedQuery(name = "Organizations.findByLawAdress", query = "SELECT o FROM Organizations o WHERE o.lawAdress = :lawAdress"),
    @NamedQuery(name = "Organizations.findByAddress", query = "SELECT o FROM Organizations o WHERE o.address = :address"),
    @NamedQuery(name = "Organizations.findByCity", query = "SELECT o FROM Organizations o WHERE o.city = :city"),
    @NamedQuery(name = "Organizations.findByZipcode", query = "SELECT o FROM Organizations o WHERE o.zipcode = :zipcode"),
    @NamedQuery(name = "Organizations.findByInn", query = "SELECT o FROM Organizations o WHERE o.inn = :inn"),
    @NamedQuery(name = "Organizations.findByOkpo", query = "SELECT o FROM Organizations o WHERE o.okpo = :okpo"),
    @NamedQuery(name = "Organizations.findByPrFio", query = "SELECT o FROM Organizations o WHERE o.prFio = :prFio"),
    @NamedQuery(name = "Organizations.findByPrPost", query = "SELECT o FROM Organizations o WHERE o.prPost = :prPost"),
    @NamedQuery(name = "Organizations.findByPrContact", query = "SELECT o FROM Organizations o WHERE o.prContact = :prContact"),
    @NamedQuery(name = "Organizations.findByPhone", query = "SELECT o FROM Organizations o WHERE o.phone = :phone")})
public class Organizations implements Serializable {
    private static final long serialVersionUID = 1L;
    @Column(name = "SYS_FLDORDER")
    private Integer sysFldorder;
    @Id
    @Basic(optional = false)
    @Column(name = "SYS_GUID")
    private String sysGuid;
    @Column(name = "SYS_STATE")
    private Integer sysState;
    @Column(name = "SYS_REV")
    private BigInteger sysRev;
    @Column(name = "SYS_CREATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysCreated;
    @Column(name = "SYS_UPDATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysUpdated;
    @Column(name = "SYS_CREATOR")
    private String sysCreator;
    @Column(name = "SYS_USER")
    private String sysUser;
    @Column(name = "SYS_GUIDFK")
    private String sysGuidfk;
    @Column(name = "SYS_PARENTGUID")
    private String sysParentguid;
    @Column(name = "ORGNAME")
    private String orgname;
    @Column(name = "LAW_ADRESS")
    private String lawAdress;
    @Column(name = "ADDRESS")
    private String address;
    @Column(name = "CITY")
    private String city;
    @Column(name = "ZIPCODE")
    private String zipcode;
    @Lob
    @Column(name = "FULLNAME")
    private String fullname;
    @Lob
    @Column(name = "NOTE")
    private String note;
    @Column(name = "INN")
    private String inn;
    @Column(name = "OKPO")
    private String okpo;
    @Column(name = "PR_FIO")
    private String prFio;
    @Column(name = "PR_POST")
    private String prPost;
    @Column(name = "PR_CONTACT")
    private String prContact;
    @Column(name = "PHONE")
    private String phone;

    public Organizations() {
    }

    public Organizations(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysFldorder() {
        return sysFldorder;
    }

    public void setSysFldorder(Integer sysFldorder) {
        this.sysFldorder = sysFldorder;
    }

    public String getSysGuid() {
        return sysGuid;
    }

    public void setSysGuid(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysState() {
        return sysState;
    }

    public void setSysState(Integer sysState) {
        this.sysState = sysState;
    }

    public BigInteger getSysRev() {
        return sysRev;
    }

    public void setSysRev(BigInteger sysRev) {
        this.sysRev = sysRev;
    }

    public Date getSysCreated() {
        return sysCreated;
    }

    public void setSysCreated(Date sysCreated) {
        this.sysCreated = sysCreated;
    }

    public Date getSysUpdated() {
        return sysUpdated;
    }

    public void setSysUpdated(Date sysUpdated) {
        this.sysUpdated = sysUpdated;
    }

    public String getSysCreator() {
        return sysCreator;
    }

    public void setSysCreator(String sysCreator) {
        this.sysCreator = sysCreator;
    }

    public String getSysUser() {
        return sysUser;
    }

    public void setSysUser(String sysUser) {
        this.sysUser = sysUser;
    }

    public String getSysGuidfk() {
        return sysGuidfk;
    }

    public void setSysGuidfk(String sysGuidfk) {
        this.sysGuidfk = sysGuidfk;
    }

    public String getSysParentguid() {
        return sysParentguid;
    }

    public void setSysParentguid(String sysParentguid) {
        this.sysParentguid = sysParentguid;
    }

    public String getOrgname() {
        return orgname;
    }

    public void setOrgname(String orgname) {
        this.orgname = orgname;
    }

    public String getLawAdress() {
        return lawAdress;
    }

    public void setLawAdress(String lawAdress) {
        this.lawAdress = lawAdress;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getZipcode() {
        return zipcode;
    }

    public void setZipcode(String zipcode) {
        this.zipcode = zipcode;
    }

    public String getFullname() {
        return fullname;
    }

    public void setFullname(String fullname) {
        this.fullname = fullname;
    }

    public String getNote() {
        return note;
    }

    public void setNote(String note) {
        this.note = note;
    }

    public String getInn() {
        return inn;
    }

    public void setInn(String inn) {
        this.inn = inn;
    }

    public String getOkpo() {
        return okpo;
    }

    public void setOkpo(String okpo) {
        this.okpo = okpo;
    }

    public String getPrFio() {
        return prFio;
    }

    public void setPrFio(String prFio) {
        this.prFio = prFio;
    }

    public String getPrPost() {
        return prPost;
    }

    public void setPrPost(String prPost) {
        this.prPost = prPost;
    }

    public String getPrContact() {
        return prContact;
    }

    public void setPrContact(String prContact) {
        this.prContact = prContact;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (sysGuid != null ? sysGuid.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Organizations)) {
            return false;
        }
        Organizations other = (Organizations) object;
        if ((this.sysGuid == null && other.sysGuid != null) || (this.sysGuid != null && !this.sysGuid.equals(other.sysGuid))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "javaapplication1.entity.Organizations[ sysGuid=" + sysGuid + " ]";
    }
    
}
